home *** CD-ROM | disk | FTP | other *** search
/ EnigmA Amiga Run 1996 June / EnigmA AMIGA RUN 08 (1996)(G.R. Edizioni)(IT)[!][issue 1996-06][EARSAN CD VII].iso / earcd / utmisc1 / esclc20f.lha / Examples / OldEasyCalc.calc (.txt) < prev    next >
EasyCalc Spreadsheet file  |  1996-03-31  |  2KB  |  76 lines
  1. EASY30HED1
  2. B'This worksheet demonstrates all the EasyCalc functions available:
  3. "Range to work on:
  4. "Total:
  5.     "Average:
  6. "Minimum value:
  7. "Maximum value:
  8. "'All the standard maths operators:
  9. "10 + 2
  10. "10 - 2
  11. "10 * 2
  12. "10 / 2
  13. "10 ^ 2
  14. "10 <> 5
  15. "10 = 5
  16. "10 >= 5
  17. "10 <= 5
  18. "10 > 5
  19. "10 < 5
  20. =@SUM(A4:A7)
  21. =@AVG(A4:A7)
  22. =@MIN(A4:A7)
  23. =@MAX(A4:A7)
  24. =10+2
  25. =10-2
  26. =10*2
  27. =10/2
  28. =10^2
  29. =10<>5
  30. =10=5
  31. =10>=5
  32. =10<=5
  33. =10>5
  34. =10<5
  35. "Functions:
  36.     "abs(1.2)
  37.     "atn(1.2)
  38. "cint(1.2)
  39.     "cos(1.2)
  40.     "deg(1.2)
  41.     "exp(1.2)
  42.     "fix(1.2)
  43.     "int(1.2)
  44.     "log(1.2)
  45.     "rnd(150)
  46.     "rad(300)
  47.     "sign(-3)
  48.     "sin(1.2)
  49. "sqr(49)
  50.     "tan(1.2)
  51. "vat(399.95)
  52. "Conditionals:
  53. "IF 5<15, 1 ELSE 0
  54. =@ABS(1.2)
  55. =@ATN(1.2)
  56. =@CINT(1.2)
  57. =@COS(1.2)
  58. =@DEG(1.2)
  59. =@EXP(1.2)
  60. =@FIX(1.2)
  61. =@INT(1.2)
  62. =@LOG(1.2)
  63. =@RND(150)
  64. =@RAD(300)
  65. =@SIGN(-3)
  66. =@SIN(1.2)
  67.     =@SQR(49)
  68. =@TAN(1.2)
  69. =@VAT(399.95)
  70. =@IF(5<15,1,0)
  71. '[PRESS HELP HERE]
  72. This worksheet was originally supplied with EasyCalc
  73. Classic, nearly three years ago. Here it has been converted from
  74. EasyCalc Classic, to EasyCalc Plus, and now to EasyCalc 2.0
  75. just to demonstrate how compatible they are with each other.PALL
  76.